package com.ttj.domain.oracle.gen;

import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class OrderRecCriteria {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    protected Integer mysqlOffset;

    protected Integer mysqlLength;

    public OrderRecCriteria() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    /**
     * @param mysqlOffset 
	 *            指定返回记录行的偏移量<br>
	 *            mysqlOffset= 5,mysqlLength=10;  // 检索记录行 6-15
     */
    public void setMysqlOffset(Integer mysqlOffset) {
        this.mysqlOffset=mysqlOffset;
    }

    /**
     * @param mysqlLength 
	 *            指定返回记录行的最大数目<br>
	 *            mysqlOffset= 5,mysqlLength=10;  // 检索记录行 6-15
     */
    public Integer getMysqlOffset() {
        return mysqlOffset;
    }

    /**
     * @param mysqlOffset 
	 *            指定返回记录行的偏移量<br>
	 *            mysqlOffset= 5,mysqlLength=10;  // 检索记录行 6-15
     */
    public void setMysqlLength(Integer mysqlLength) {
        this.mysqlLength=mysqlLength;
    }

    /**
     * @param mysqlLength 
	 *            指定返回记录行的最大数目<br>
	 *            mysqlOffset= 5,mysqlLength=10;  // 检索记录行 6-15
     */
    public Integer getMysqlLength() {
        return mysqlLength;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("ID is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("ID is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("ID =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("ID <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("ID >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("ID >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("ID <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("ID <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("ID in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("ID not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("ID between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("ID not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andOrderIdIsNull() {
            addCriterion("ORDER_ID is null");
            return (Criteria) this;
        }

        public Criteria andOrderIdIsNotNull() {
            addCriterion("ORDER_ID is not null");
            return (Criteria) this;
        }

        public Criteria andOrderIdEqualTo(Long value) {
            addCriterion("ORDER_ID =", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotEqualTo(Long value) {
            addCriterion("ORDER_ID <>", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThan(Long value) {
            addCriterion("ORDER_ID >", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThanOrEqualTo(Long value) {
            addCriterion("ORDER_ID >=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThan(Long value) {
            addCriterion("ORDER_ID <", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThanOrEqualTo(Long value) {
            addCriterion("ORDER_ID <=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdIn(List<Long> values) {
            addCriterion("ORDER_ID in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotIn(List<Long> values) {
            addCriterion("ORDER_ID not in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdBetween(Long value1, Long value2) {
            addCriterion("ORDER_ID between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotBetween(Long value1, Long value2) {
            addCriterion("ORDER_ID not between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andCidIsNull() {
            addCriterion("CID is null");
            return (Criteria) this;
        }

        public Criteria andCidIsNotNull() {
            addCriterion("CID is not null");
            return (Criteria) this;
        }

        public Criteria andCidEqualTo(Integer value) {
            addCriterion("CID =", value, "cid");
            return (Criteria) this;
        }

        public Criteria andCidNotEqualTo(Integer value) {
            addCriterion("CID <>", value, "cid");
            return (Criteria) this;
        }

        public Criteria andCidGreaterThan(Integer value) {
            addCriterion("CID >", value, "cid");
            return (Criteria) this;
        }

        public Criteria andCidGreaterThanOrEqualTo(Integer value) {
            addCriterion("CID >=", value, "cid");
            return (Criteria) this;
        }

        public Criteria andCidLessThan(Integer value) {
            addCriterion("CID <", value, "cid");
            return (Criteria) this;
        }

        public Criteria andCidLessThanOrEqualTo(Integer value) {
            addCriterion("CID <=", value, "cid");
            return (Criteria) this;
        }

        public Criteria andCidIn(List<Integer> values) {
            addCriterion("CID in", values, "cid");
            return (Criteria) this;
        }

        public Criteria andCidNotIn(List<Integer> values) {
            addCriterion("CID not in", values, "cid");
            return (Criteria) this;
        }

        public Criteria andCidBetween(Integer value1, Integer value2) {
            addCriterion("CID between", value1, value2, "cid");
            return (Criteria) this;
        }

        public Criteria andCidNotBetween(Integer value1, Integer value2) {
            addCriterion("CID not between", value1, value2, "cid");
            return (Criteria) this;
        }

        public Criteria andCextIdIsNull() {
            addCriterion("CEXT_ID is null");
            return (Criteria) this;
        }

        public Criteria andCextIdIsNotNull() {
            addCriterion("CEXT_ID is not null");
            return (Criteria) this;
        }

        public Criteria andCextIdEqualTo(Integer value) {
            addCriterion("CEXT_ID =", value, "cextId");
            return (Criteria) this;
        }

        public Criteria andCextIdNotEqualTo(Integer value) {
            addCriterion("CEXT_ID <>", value, "cextId");
            return (Criteria) this;
        }

        public Criteria andCextIdGreaterThan(Integer value) {
            addCriterion("CEXT_ID >", value, "cextId");
            return (Criteria) this;
        }

        public Criteria andCextIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("CEXT_ID >=", value, "cextId");
            return (Criteria) this;
        }

        public Criteria andCextIdLessThan(Integer value) {
            addCriterion("CEXT_ID <", value, "cextId");
            return (Criteria) this;
        }

        public Criteria andCextIdLessThanOrEqualTo(Integer value) {
            addCriterion("CEXT_ID <=", value, "cextId");
            return (Criteria) this;
        }

        public Criteria andCextIdIn(List<Integer> values) {
            addCriterion("CEXT_ID in", values, "cextId");
            return (Criteria) this;
        }

        public Criteria andCextIdNotIn(List<Integer> values) {
            addCriterion("CEXT_ID not in", values, "cextId");
            return (Criteria) this;
        }

        public Criteria andCextIdBetween(Integer value1, Integer value2) {
            addCriterion("CEXT_ID between", value1, value2, "cextId");
            return (Criteria) this;
        }

        public Criteria andCextIdNotBetween(Integer value1, Integer value2) {
            addCriterion("CEXT_ID not between", value1, value2, "cextId");
            return (Criteria) this;
        }

        public Criteria andCphoneIsNull() {
            addCriterion("CPHONE is null");
            return (Criteria) this;
        }

        public Criteria andCphoneIsNotNull() {
            addCriterion("CPHONE is not null");
            return (Criteria) this;
        }

        public Criteria andCphoneEqualTo(String value) {
            addCriterion("CPHONE =", value, "cphone");
            return (Criteria) this;
        }

        public Criteria andCphoneNotEqualTo(String value) {
            addCriterion("CPHONE <>", value, "cphone");
            return (Criteria) this;
        }

        public Criteria andCphoneGreaterThan(String value) {
            addCriterion("CPHONE >", value, "cphone");
            return (Criteria) this;
        }

        public Criteria andCphoneGreaterThanOrEqualTo(String value) {
            addCriterion("CPHONE >=", value, "cphone");
            return (Criteria) this;
        }

        public Criteria andCphoneLessThan(String value) {
            addCriterion("CPHONE <", value, "cphone");
            return (Criteria) this;
        }

        public Criteria andCphoneLessThanOrEqualTo(String value) {
            addCriterion("CPHONE <=", value, "cphone");
            return (Criteria) this;
        }

        public Criteria andCphoneLike(String value) {
            addCriterion("CPHONE like", value, "cphone");
            return (Criteria) this;
        }

        public Criteria andCphoneNotLike(String value) {
            addCriterion("CPHONE not like", value, "cphone");
            return (Criteria) this;
        }

        public Criteria andCphoneIn(List<String> values) {
            addCriterion("CPHONE in", values, "cphone");
            return (Criteria) this;
        }

        public Criteria andCphoneNotIn(List<String> values) {
            addCriterion("CPHONE not in", values, "cphone");
            return (Criteria) this;
        }

        public Criteria andCphoneBetween(String value1, String value2) {
            addCriterion("CPHONE between", value1, value2, "cphone");
            return (Criteria) this;
        }

        public Criteria andCphoneNotBetween(String value1, String value2) {
            addCriterion("CPHONE not between", value1, value2, "cphone");
            return (Criteria) this;
        }

        public Criteria andStypeIsNull() {
            addCriterion("STYPE is null");
            return (Criteria) this;
        }

        public Criteria andStypeIsNotNull() {
            addCriterion("STYPE is not null");
            return (Criteria) this;
        }

        public Criteria andStypeEqualTo(Integer value) {
            addCriterion("STYPE =", value, "stype");
            return (Criteria) this;
        }

        public Criteria andStypeNotEqualTo(Integer value) {
            addCriterion("STYPE <>", value, "stype");
            return (Criteria) this;
        }

        public Criteria andStypeGreaterThan(Integer value) {
            addCriterion("STYPE >", value, "stype");
            return (Criteria) this;
        }

        public Criteria andStypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("STYPE >=", value, "stype");
            return (Criteria) this;
        }

        public Criteria andStypeLessThan(Integer value) {
            addCriterion("STYPE <", value, "stype");
            return (Criteria) this;
        }

        public Criteria andStypeLessThanOrEqualTo(Integer value) {
            addCriterion("STYPE <=", value, "stype");
            return (Criteria) this;
        }

        public Criteria andStypeIn(List<Integer> values) {
            addCriterion("STYPE in", values, "stype");
            return (Criteria) this;
        }

        public Criteria andStypeNotIn(List<Integer> values) {
            addCriterion("STYPE not in", values, "stype");
            return (Criteria) this;
        }

        public Criteria andStypeBetween(Integer value1, Integer value2) {
            addCriterion("STYPE between", value1, value2, "stype");
            return (Criteria) this;
        }

        public Criteria andStypeNotBetween(Integer value1, Integer value2) {
            addCriterion("STYPE not between", value1, value2, "stype");
            return (Criteria) this;
        }

        public Criteria andPriceIsNull() {
            addCriterion("PRICE is null");
            return (Criteria) this;
        }

        public Criteria andPriceIsNotNull() {
            addCriterion("PRICE is not null");
            return (Criteria) this;
        }

        public Criteria andPriceEqualTo(Double value) {
            addCriterion("PRICE =", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotEqualTo(Double value) {
            addCriterion("PRICE <>", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceGreaterThan(Double value) {
            addCriterion("PRICE >", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceGreaterThanOrEqualTo(Double value) {
            addCriterion("PRICE >=", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceLessThan(Double value) {
            addCriterion("PRICE <", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceLessThanOrEqualTo(Double value) {
            addCriterion("PRICE <=", value, "price");
            return (Criteria) this;
        }

        public Criteria andPriceIn(List<Double> values) {
            addCriterion("PRICE in", values, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotIn(List<Double> values) {
            addCriterion("PRICE not in", values, "price");
            return (Criteria) this;
        }

        public Criteria andPriceBetween(Double value1, Double value2) {
            addCriterion("PRICE between", value1, value2, "price");
            return (Criteria) this;
        }

        public Criteria andPriceNotBetween(Double value1, Double value2) {
            addCriterion("PRICE not between", value1, value2, "price");
            return (Criteria) this;
        }

        public Criteria andPayMethodIsNull() {
            addCriterion("PAY_METHOD is null");
            return (Criteria) this;
        }

        public Criteria andPayMethodIsNotNull() {
            addCriterion("PAY_METHOD is not null");
            return (Criteria) this;
        }

        public Criteria andPayMethodEqualTo(Integer value) {
            addCriterion("PAY_METHOD =", value, "payMethod");
            return (Criteria) this;
        }

        public Criteria andPayMethodNotEqualTo(Integer value) {
            addCriterion("PAY_METHOD <>", value, "payMethod");
            return (Criteria) this;
        }

        public Criteria andPayMethodGreaterThan(Integer value) {
            addCriterion("PAY_METHOD >", value, "payMethod");
            return (Criteria) this;
        }

        public Criteria andPayMethodGreaterThanOrEqualTo(Integer value) {
            addCriterion("PAY_METHOD >=", value, "payMethod");
            return (Criteria) this;
        }

        public Criteria andPayMethodLessThan(Integer value) {
            addCriterion("PAY_METHOD <", value, "payMethod");
            return (Criteria) this;
        }

        public Criteria andPayMethodLessThanOrEqualTo(Integer value) {
            addCriterion("PAY_METHOD <=", value, "payMethod");
            return (Criteria) this;
        }

        public Criteria andPayMethodIn(List<Integer> values) {
            addCriterion("PAY_METHOD in", values, "payMethod");
            return (Criteria) this;
        }

        public Criteria andPayMethodNotIn(List<Integer> values) {
            addCriterion("PAY_METHOD not in", values, "payMethod");
            return (Criteria) this;
        }

        public Criteria andPayMethodBetween(Integer value1, Integer value2) {
            addCriterion("PAY_METHOD between", value1, value2, "payMethod");
            return (Criteria) this;
        }

        public Criteria andPayMethodNotBetween(Integer value1, Integer value2) {
            addCriterion("PAY_METHOD not between", value1, value2, "payMethod");
            return (Criteria) this;
        }

        public Criteria andCommentsIsNull() {
            addCriterion("COMMENTS is null");
            return (Criteria) this;
        }

        public Criteria andCommentsIsNotNull() {
            addCriterion("COMMENTS is not null");
            return (Criteria) this;
        }

        public Criteria andCommentsEqualTo(String value) {
            addCriterion("COMMENTS =", value, "comments");
            return (Criteria) this;
        }

        public Criteria andCommentsNotEqualTo(String value) {
            addCriterion("COMMENTS <>", value, "comments");
            return (Criteria) this;
        }

        public Criteria andCommentsGreaterThan(String value) {
            addCriterion("COMMENTS >", value, "comments");
            return (Criteria) this;
        }

        public Criteria andCommentsGreaterThanOrEqualTo(String value) {
            addCriterion("COMMENTS >=", value, "comments");
            return (Criteria) this;
        }

        public Criteria andCommentsLessThan(String value) {
            addCriterion("COMMENTS <", value, "comments");
            return (Criteria) this;
        }

        public Criteria andCommentsLessThanOrEqualTo(String value) {
            addCriterion("COMMENTS <=", value, "comments");
            return (Criteria) this;
        }

        public Criteria andCommentsLike(String value) {
            addCriterion("COMMENTS like", value, "comments");
            return (Criteria) this;
        }

        public Criteria andCommentsNotLike(String value) {
            addCriterion("COMMENTS not like", value, "comments");
            return (Criteria) this;
        }

        public Criteria andCommentsIn(List<String> values) {
            addCriterion("COMMENTS in", values, "comments");
            return (Criteria) this;
        }

        public Criteria andCommentsNotIn(List<String> values) {
            addCriterion("COMMENTS not in", values, "comments");
            return (Criteria) this;
        }

        public Criteria andCommentsBetween(String value1, String value2) {
            addCriterion("COMMENTS between", value1, value2, "comments");
            return (Criteria) this;
        }

        public Criteria andCommentsNotBetween(String value1, String value2) {
            addCriterion("COMMENTS not between", value1, value2, "comments");
            return (Criteria) this;
        }

        public Criteria andOStatusIsNull() {
            addCriterion("O_STATUS is null");
            return (Criteria) this;
        }

        public Criteria andOStatusIsNotNull() {
            addCriterion("O_STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andOStatusEqualTo(Integer value) {
            addCriterion("O_STATUS =", value, "oStatus");
            return (Criteria) this;
        }

        public Criteria andOStatusNotEqualTo(Integer value) {
            addCriterion("O_STATUS <>", value, "oStatus");
            return (Criteria) this;
        }

        public Criteria andOStatusGreaterThan(Integer value) {
            addCriterion("O_STATUS >", value, "oStatus");
            return (Criteria) this;
        }

        public Criteria andOStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("O_STATUS >=", value, "oStatus");
            return (Criteria) this;
        }

        public Criteria andOStatusLessThan(Integer value) {
            addCriterion("O_STATUS <", value, "oStatus");
            return (Criteria) this;
        }

        public Criteria andOStatusLessThanOrEqualTo(Integer value) {
            addCriterion("O_STATUS <=", value, "oStatus");
            return (Criteria) this;
        }

        public Criteria andOStatusIn(List<Integer> values) {
            addCriterion("O_STATUS in", values, "oStatus");
            return (Criteria) this;
        }

        public Criteria andOStatusNotIn(List<Integer> values) {
            addCriterion("O_STATUS not in", values, "oStatus");
            return (Criteria) this;
        }

        public Criteria andOStatusBetween(Integer value1, Integer value2) {
            addCriterion("O_STATUS between", value1, value2, "oStatus");
            return (Criteria) this;
        }

        public Criteria andOStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("O_STATUS not between", value1, value2, "oStatus");
            return (Criteria) this;
        }

        public Criteria andOIndateIsNull() {
            addCriterion("O_INDATE is null");
            return (Criteria) this;
        }

        public Criteria andOIndateIsNotNull() {
            addCriterion("O_INDATE is not null");
            return (Criteria) this;
        }

        public Criteria andOIndateEqualTo(Date value) {
            addCriterion("O_INDATE =", value, "oIndate");
            return (Criteria) this;
        }

        public Criteria andOIndateNotEqualTo(Date value) {
            addCriterion("O_INDATE <>", value, "oIndate");
            return (Criteria) this;
        }

        public Criteria andOIndateGreaterThan(Date value) {
            addCriterion("O_INDATE >", value, "oIndate");
            return (Criteria) this;
        }

        public Criteria andOIndateGreaterThanOrEqualTo(Date value) {
            addCriterion("O_INDATE >=", value, "oIndate");
            return (Criteria) this;
        }

        public Criteria andOIndateLessThan(Date value) {
            addCriterion("O_INDATE <", value, "oIndate");
            return (Criteria) this;
        }

        public Criteria andOIndateLessThanOrEqualTo(Date value) {
            addCriterion("O_INDATE <=", value, "oIndate");
            return (Criteria) this;
        }

        public Criteria andOIndateIn(List<Date> values) {
            addCriterion("O_INDATE in", values, "oIndate");
            return (Criteria) this;
        }

        public Criteria andOIndateNotIn(List<Date> values) {
            addCriterion("O_INDATE not in", values, "oIndate");
            return (Criteria) this;
        }

        public Criteria andOIndateBetween(Date value1, Date value2) {
            addCriterion("O_INDATE between", value1, value2, "oIndate");
            return (Criteria) this;
        }

        public Criteria andOIndateNotBetween(Date value1, Date value2) {
            addCriterion("O_INDATE not between", value1, value2, "oIndate");
            return (Criteria) this;
        }

        public Criteria andODTimeIsNull() {
            addCriterion("O_D_TIME is null");
            return (Criteria) this;
        }

        public Criteria andODTimeIsNotNull() {
            addCriterion("O_D_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andODTimeEqualTo(Date value) {
            addCriterion("O_D_TIME =", value, "oDTime");
            return (Criteria) this;
        }

        public Criteria andODTimeNotEqualTo(Date value) {
            addCriterion("O_D_TIME <>", value, "oDTime");
            return (Criteria) this;
        }

        public Criteria andODTimeGreaterThan(Date value) {
            addCriterion("O_D_TIME >", value, "oDTime");
            return (Criteria) this;
        }

        public Criteria andODTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("O_D_TIME >=", value, "oDTime");
            return (Criteria) this;
        }

        public Criteria andODTimeLessThan(Date value) {
            addCriterion("O_D_TIME <", value, "oDTime");
            return (Criteria) this;
        }

        public Criteria andODTimeLessThanOrEqualTo(Date value) {
            addCriterion("O_D_TIME <=", value, "oDTime");
            return (Criteria) this;
        }

        public Criteria andODTimeIn(List<Date> values) {
            addCriterion("O_D_TIME in", values, "oDTime");
            return (Criteria) this;
        }

        public Criteria andODTimeNotIn(List<Date> values) {
            addCriterion("O_D_TIME not in", values, "oDTime");
            return (Criteria) this;
        }

        public Criteria andODTimeBetween(Date value1, Date value2) {
            addCriterion("O_D_TIME between", value1, value2, "oDTime");
            return (Criteria) this;
        }

        public Criteria andODTimeNotBetween(Date value1, Date value2) {
            addCriterion("O_D_TIME not between", value1, value2, "oDTime");
            return (Criteria) this;
        }

        public Criteria andODAuthorIsNull() {
            addCriterion("O_D_AUTHOR is null");
            return (Criteria) this;
        }

        public Criteria andODAuthorIsNotNull() {
            addCriterion("O_D_AUTHOR is not null");
            return (Criteria) this;
        }

        public Criteria andODAuthorEqualTo(String value) {
            addCriterion("O_D_AUTHOR =", value, "oDAuthor");
            return (Criteria) this;
        }

        public Criteria andODAuthorNotEqualTo(String value) {
            addCriterion("O_D_AUTHOR <>", value, "oDAuthor");
            return (Criteria) this;
        }

        public Criteria andODAuthorGreaterThan(String value) {
            addCriterion("O_D_AUTHOR >", value, "oDAuthor");
            return (Criteria) this;
        }

        public Criteria andODAuthorGreaterThanOrEqualTo(String value) {
            addCriterion("O_D_AUTHOR >=", value, "oDAuthor");
            return (Criteria) this;
        }

        public Criteria andODAuthorLessThan(String value) {
            addCriterion("O_D_AUTHOR <", value, "oDAuthor");
            return (Criteria) this;
        }

        public Criteria andODAuthorLessThanOrEqualTo(String value) {
            addCriterion("O_D_AUTHOR <=", value, "oDAuthor");
            return (Criteria) this;
        }

        public Criteria andODAuthorLike(String value) {
            addCriterion("O_D_AUTHOR like", value, "oDAuthor");
            return (Criteria) this;
        }

        public Criteria andODAuthorNotLike(String value) {
            addCriterion("O_D_AUTHOR not like", value, "oDAuthor");
            return (Criteria) this;
        }

        public Criteria andODAuthorIn(List<String> values) {
            addCriterion("O_D_AUTHOR in", values, "oDAuthor");
            return (Criteria) this;
        }

        public Criteria andODAuthorNotIn(List<String> values) {
            addCriterion("O_D_AUTHOR not in", values, "oDAuthor");
            return (Criteria) this;
        }

        public Criteria andODAuthorBetween(String value1, String value2) {
            addCriterion("O_D_AUTHOR between", value1, value2, "oDAuthor");
            return (Criteria) this;
        }

        public Criteria andODAuthorNotBetween(String value1, String value2) {
            addCriterion("O_D_AUTHOR not between", value1, value2, "oDAuthor");
            return (Criteria) this;
        }

        public Criteria andOCTimeIsNull() {
            addCriterion("O_C_TIME is null");
            return (Criteria) this;
        }

        public Criteria andOCTimeIsNotNull() {
            addCriterion("O_C_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andOCTimeEqualTo(Date value) {
            addCriterion("O_C_TIME =", value, "oCTime");
            return (Criteria) this;
        }

        public Criteria andOCTimeNotEqualTo(Date value) {
            addCriterion("O_C_TIME <>", value, "oCTime");
            return (Criteria) this;
        }

        public Criteria andOCTimeGreaterThan(Date value) {
            addCriterion("O_C_TIME >", value, "oCTime");
            return (Criteria) this;
        }

        public Criteria andOCTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("O_C_TIME >=", value, "oCTime");
            return (Criteria) this;
        }

        public Criteria andOCTimeLessThan(Date value) {
            addCriterion("O_C_TIME <", value, "oCTime");
            return (Criteria) this;
        }

        public Criteria andOCTimeLessThanOrEqualTo(Date value) {
            addCriterion("O_C_TIME <=", value, "oCTime");
            return (Criteria) this;
        }

        public Criteria andOCTimeIn(List<Date> values) {
            addCriterion("O_C_TIME in", values, "oCTime");
            return (Criteria) this;
        }

        public Criteria andOCTimeNotIn(List<Date> values) {
            addCriterion("O_C_TIME not in", values, "oCTime");
            return (Criteria) this;
        }

        public Criteria andOCTimeBetween(Date value1, Date value2) {
            addCriterion("O_C_TIME between", value1, value2, "oCTime");
            return (Criteria) this;
        }

        public Criteria andOCTimeNotBetween(Date value1, Date value2) {
            addCriterion("O_C_TIME not between", value1, value2, "oCTime");
            return (Criteria) this;
        }

        public Criteria andOCAuthorIsNull() {
            addCriterion("O_C_AUTHOR is null");
            return (Criteria) this;
        }

        public Criteria andOCAuthorIsNotNull() {
            addCriterion("O_C_AUTHOR is not null");
            return (Criteria) this;
        }

        public Criteria andOCAuthorEqualTo(String value) {
            addCriterion("O_C_AUTHOR =", value, "oCAuthor");
            return (Criteria) this;
        }

        public Criteria andOCAuthorNotEqualTo(String value) {
            addCriterion("O_C_AUTHOR <>", value, "oCAuthor");
            return (Criteria) this;
        }

        public Criteria andOCAuthorGreaterThan(String value) {
            addCriterion("O_C_AUTHOR >", value, "oCAuthor");
            return (Criteria) this;
        }

        public Criteria andOCAuthorGreaterThanOrEqualTo(String value) {
            addCriterion("O_C_AUTHOR >=", value, "oCAuthor");
            return (Criteria) this;
        }

        public Criteria andOCAuthorLessThan(String value) {
            addCriterion("O_C_AUTHOR <", value, "oCAuthor");
            return (Criteria) this;
        }

        public Criteria andOCAuthorLessThanOrEqualTo(String value) {
            addCriterion("O_C_AUTHOR <=", value, "oCAuthor");
            return (Criteria) this;
        }

        public Criteria andOCAuthorLike(String value) {
            addCriterion("O_C_AUTHOR like", value, "oCAuthor");
            return (Criteria) this;
        }

        public Criteria andOCAuthorNotLike(String value) {
            addCriterion("O_C_AUTHOR not like", value, "oCAuthor");
            return (Criteria) this;
        }

        public Criteria andOCAuthorIn(List<String> values) {
            addCriterion("O_C_AUTHOR in", values, "oCAuthor");
            return (Criteria) this;
        }

        public Criteria andOCAuthorNotIn(List<String> values) {
            addCriterion("O_C_AUTHOR not in", values, "oCAuthor");
            return (Criteria) this;
        }

        public Criteria andOCAuthorBetween(String value1, String value2) {
            addCriterion("O_C_AUTHOR between", value1, value2, "oCAuthor");
            return (Criteria) this;
        }

        public Criteria andOCAuthorNotBetween(String value1, String value2) {
            addCriterion("O_C_AUTHOR not between", value1, value2, "oCAuthor");
            return (Criteria) this;
        }

        public Criteria andOSTimeIsNull() {
            addCriterion("O_S_TIME is null");
            return (Criteria) this;
        }

        public Criteria andOSTimeIsNotNull() {
            addCriterion("O_S_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andOSTimeEqualTo(Date value) {
            addCriterion("O_S_TIME =", value, "oSTime");
            return (Criteria) this;
        }

        public Criteria andOSTimeNotEqualTo(Date value) {
            addCriterion("O_S_TIME <>", value, "oSTime");
            return (Criteria) this;
        }

        public Criteria andOSTimeGreaterThan(Date value) {
            addCriterion("O_S_TIME >", value, "oSTime");
            return (Criteria) this;
        }

        public Criteria andOSTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("O_S_TIME >=", value, "oSTime");
            return (Criteria) this;
        }

        public Criteria andOSTimeLessThan(Date value) {
            addCriterion("O_S_TIME <", value, "oSTime");
            return (Criteria) this;
        }

        public Criteria andOSTimeLessThanOrEqualTo(Date value) {
            addCriterion("O_S_TIME <=", value, "oSTime");
            return (Criteria) this;
        }

        public Criteria andOSTimeIn(List<Date> values) {
            addCriterion("O_S_TIME in", values, "oSTime");
            return (Criteria) this;
        }

        public Criteria andOSTimeNotIn(List<Date> values) {
            addCriterion("O_S_TIME not in", values, "oSTime");
            return (Criteria) this;
        }

        public Criteria andOSTimeBetween(Date value1, Date value2) {
            addCriterion("O_S_TIME between", value1, value2, "oSTime");
            return (Criteria) this;
        }

        public Criteria andOSTimeNotBetween(Date value1, Date value2) {
            addCriterion("O_S_TIME not between", value1, value2, "oSTime");
            return (Criteria) this;
        }

        public Criteria andOSAuthorIsNull() {
            addCriterion("O_S_AUTHOR is null");
            return (Criteria) this;
        }

        public Criteria andOSAuthorIsNotNull() {
            addCriterion("O_S_AUTHOR is not null");
            return (Criteria) this;
        }

        public Criteria andOSAuthorEqualTo(String value) {
            addCriterion("O_S_AUTHOR =", value, "oSAuthor");
            return (Criteria) this;
        }

        public Criteria andOSAuthorNotEqualTo(String value) {
            addCriterion("O_S_AUTHOR <>", value, "oSAuthor");
            return (Criteria) this;
        }

        public Criteria andOSAuthorGreaterThan(String value) {
            addCriterion("O_S_AUTHOR >", value, "oSAuthor");
            return (Criteria) this;
        }

        public Criteria andOSAuthorGreaterThanOrEqualTo(String value) {
            addCriterion("O_S_AUTHOR >=", value, "oSAuthor");
            return (Criteria) this;
        }

        public Criteria andOSAuthorLessThan(String value) {
            addCriterion("O_S_AUTHOR <", value, "oSAuthor");
            return (Criteria) this;
        }

        public Criteria andOSAuthorLessThanOrEqualTo(String value) {
            addCriterion("O_S_AUTHOR <=", value, "oSAuthor");
            return (Criteria) this;
        }

        public Criteria andOSAuthorLike(String value) {
            addCriterion("O_S_AUTHOR like", value, "oSAuthor");
            return (Criteria) this;
        }

        public Criteria andOSAuthorNotLike(String value) {
            addCriterion("O_S_AUTHOR not like", value, "oSAuthor");
            return (Criteria) this;
        }

        public Criteria andOSAuthorIn(List<String> values) {
            addCriterion("O_S_AUTHOR in", values, "oSAuthor");
            return (Criteria) this;
        }

        public Criteria andOSAuthorNotIn(List<String> values) {
            addCriterion("O_S_AUTHOR not in", values, "oSAuthor");
            return (Criteria) this;
        }

        public Criteria andOSAuthorBetween(String value1, String value2) {
            addCriterion("O_S_AUTHOR between", value1, value2, "oSAuthor");
            return (Criteria) this;
        }

        public Criteria andOSAuthorNotBetween(String value1, String value2) {
            addCriterion("O_S_AUTHOR not between", value1, value2, "oSAuthor");
            return (Criteria) this;
        }

        public Criteria andFStatusIsNull() {
            addCriterion("F_STATUS is null");
            return (Criteria) this;
        }

        public Criteria andFStatusIsNotNull() {
            addCriterion("F_STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andFStatusEqualTo(Integer value) {
            addCriterion("F_STATUS =", value, "fStatus");
            return (Criteria) this;
        }

        public Criteria andFStatusNotEqualTo(Integer value) {
            addCriterion("F_STATUS <>", value, "fStatus");
            return (Criteria) this;
        }

        public Criteria andFStatusGreaterThan(Integer value) {
            addCriterion("F_STATUS >", value, "fStatus");
            return (Criteria) this;
        }

        public Criteria andFStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("F_STATUS >=", value, "fStatus");
            return (Criteria) this;
        }

        public Criteria andFStatusLessThan(Integer value) {
            addCriterion("F_STATUS <", value, "fStatus");
            return (Criteria) this;
        }

        public Criteria andFStatusLessThanOrEqualTo(Integer value) {
            addCriterion("F_STATUS <=", value, "fStatus");
            return (Criteria) this;
        }

        public Criteria andFStatusIn(List<Integer> values) {
            addCriterion("F_STATUS in", values, "fStatus");
            return (Criteria) this;
        }

        public Criteria andFStatusNotIn(List<Integer> values) {
            addCriterion("F_STATUS not in", values, "fStatus");
            return (Criteria) this;
        }

        public Criteria andFStatusBetween(Integer value1, Integer value2) {
            addCriterion("F_STATUS between", value1, value2, "fStatus");
            return (Criteria) this;
        }

        public Criteria andFStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("F_STATUS not between", value1, value2, "fStatus");
            return (Criteria) this;
        }

        public Criteria andFJsTimeIsNull() {
            addCriterion("F_JS_TIME is null");
            return (Criteria) this;
        }

        public Criteria andFJsTimeIsNotNull() {
            addCriterion("F_JS_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andFJsTimeEqualTo(Date value) {
            addCriterion("F_JS_TIME =", value, "fJsTime");
            return (Criteria) this;
        }

        public Criteria andFJsTimeNotEqualTo(Date value) {
            addCriterion("F_JS_TIME <>", value, "fJsTime");
            return (Criteria) this;
        }

        public Criteria andFJsTimeGreaterThan(Date value) {
            addCriterion("F_JS_TIME >", value, "fJsTime");
            return (Criteria) this;
        }

        public Criteria andFJsTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("F_JS_TIME >=", value, "fJsTime");
            return (Criteria) this;
        }

        public Criteria andFJsTimeLessThan(Date value) {
            addCriterion("F_JS_TIME <", value, "fJsTime");
            return (Criteria) this;
        }

        public Criteria andFJsTimeLessThanOrEqualTo(Date value) {
            addCriterion("F_JS_TIME <=", value, "fJsTime");
            return (Criteria) this;
        }

        public Criteria andFJsTimeIn(List<Date> values) {
            addCriterion("F_JS_TIME in", values, "fJsTime");
            return (Criteria) this;
        }

        public Criteria andFJsTimeNotIn(List<Date> values) {
            addCriterion("F_JS_TIME not in", values, "fJsTime");
            return (Criteria) this;
        }

        public Criteria andFJsTimeBetween(Date value1, Date value2) {
            addCriterion("F_JS_TIME between", value1, value2, "fJsTime");
            return (Criteria) this;
        }

        public Criteria andFJsTimeNotBetween(Date value1, Date value2) {
            addCriterion("F_JS_TIME not between", value1, value2, "fJsTime");
            return (Criteria) this;
        }

        public Criteria andFJAuthorIsNull() {
            addCriterion("F_J_AUTHOR is null");
            return (Criteria) this;
        }

        public Criteria andFJAuthorIsNotNull() {
            addCriterion("F_J_AUTHOR is not null");
            return (Criteria) this;
        }

        public Criteria andFJAuthorEqualTo(String value) {
            addCriterion("F_J_AUTHOR =", value, "fJAuthor");
            return (Criteria) this;
        }

        public Criteria andFJAuthorNotEqualTo(String value) {
            addCriterion("F_J_AUTHOR <>", value, "fJAuthor");
            return (Criteria) this;
        }

        public Criteria andFJAuthorGreaterThan(String value) {
            addCriterion("F_J_AUTHOR >", value, "fJAuthor");
            return (Criteria) this;
        }

        public Criteria andFJAuthorGreaterThanOrEqualTo(String value) {
            addCriterion("F_J_AUTHOR >=", value, "fJAuthor");
            return (Criteria) this;
        }

        public Criteria andFJAuthorLessThan(String value) {
            addCriterion("F_J_AUTHOR <", value, "fJAuthor");
            return (Criteria) this;
        }

        public Criteria andFJAuthorLessThanOrEqualTo(String value) {
            addCriterion("F_J_AUTHOR <=", value, "fJAuthor");
            return (Criteria) this;
        }

        public Criteria andFJAuthorLike(String value) {
            addCriterion("F_J_AUTHOR like", value, "fJAuthor");
            return (Criteria) this;
        }

        public Criteria andFJAuthorNotLike(String value) {
            addCriterion("F_J_AUTHOR not like", value, "fJAuthor");
            return (Criteria) this;
        }

        public Criteria andFJAuthorIn(List<String> values) {
            addCriterion("F_J_AUTHOR in", values, "fJAuthor");
            return (Criteria) this;
        }

        public Criteria andFJAuthorNotIn(List<String> values) {
            addCriterion("F_J_AUTHOR not in", values, "fJAuthor");
            return (Criteria) this;
        }

        public Criteria andFJAuthorBetween(String value1, String value2) {
            addCriterion("F_J_AUTHOR between", value1, value2, "fJAuthor");
            return (Criteria) this;
        }

        public Criteria andFJAuthorNotBetween(String value1, String value2) {
            addCriterion("F_J_AUTHOR not between", value1, value2, "fJAuthor");
            return (Criteria) this;
        }

        public Criteria andFJMoneyIsNull() {
            addCriterion("F_J_MONEY is null");
            return (Criteria) this;
        }

        public Criteria andFJMoneyIsNotNull() {
            addCriterion("F_J_MONEY is not null");
            return (Criteria) this;
        }

        public Criteria andFJMoneyEqualTo(Double value) {
            addCriterion("F_J_MONEY =", value, "fJMoney");
            return (Criteria) this;
        }

        public Criteria andFJMoneyNotEqualTo(Double value) {
            addCriterion("F_J_MONEY <>", value, "fJMoney");
            return (Criteria) this;
        }

        public Criteria andFJMoneyGreaterThan(Double value) {
            addCriterion("F_J_MONEY >", value, "fJMoney");
            return (Criteria) this;
        }

        public Criteria andFJMoneyGreaterThanOrEqualTo(Double value) {
            addCriterion("F_J_MONEY >=", value, "fJMoney");
            return (Criteria) this;
        }

        public Criteria andFJMoneyLessThan(Double value) {
            addCriterion("F_J_MONEY <", value, "fJMoney");
            return (Criteria) this;
        }

        public Criteria andFJMoneyLessThanOrEqualTo(Double value) {
            addCriterion("F_J_MONEY <=", value, "fJMoney");
            return (Criteria) this;
        }

        public Criteria andFJMoneyIn(List<Double> values) {
            addCriterion("F_J_MONEY in", values, "fJMoney");
            return (Criteria) this;
        }

        public Criteria andFJMoneyNotIn(List<Double> values) {
            addCriterion("F_J_MONEY not in", values, "fJMoney");
            return (Criteria) this;
        }

        public Criteria andFJMoneyBetween(Double value1, Double value2) {
            addCriterion("F_J_MONEY between", value1, value2, "fJMoney");
            return (Criteria) this;
        }

        public Criteria andFJMoneyNotBetween(Double value1, Double value2) {
            addCriterion("F_J_MONEY not between", value1, value2, "fJMoney");
            return (Criteria) this;
        }

        public Criteria andOrderMoneyIsNull() {
            addCriterion("ORDER_MONEY is null");
            return (Criteria) this;
        }

        public Criteria andOrderMoneyIsNotNull() {
            addCriterion("ORDER_MONEY is not null");
            return (Criteria) this;
        }

        public Criteria andOrderMoneyEqualTo(Double value) {
            addCriterion("ORDER_MONEY =", value, "orderMoney");
            return (Criteria) this;
        }

        public Criteria andOrderMoneyNotEqualTo(Double value) {
            addCriterion("ORDER_MONEY <>", value, "orderMoney");
            return (Criteria) this;
        }

        public Criteria andOrderMoneyGreaterThan(Double value) {
            addCriterion("ORDER_MONEY >", value, "orderMoney");
            return (Criteria) this;
        }

        public Criteria andOrderMoneyGreaterThanOrEqualTo(Double value) {
            addCriterion("ORDER_MONEY >=", value, "orderMoney");
            return (Criteria) this;
        }

        public Criteria andOrderMoneyLessThan(Double value) {
            addCriterion("ORDER_MONEY <", value, "orderMoney");
            return (Criteria) this;
        }

        public Criteria andOrderMoneyLessThanOrEqualTo(Double value) {
            addCriterion("ORDER_MONEY <=", value, "orderMoney");
            return (Criteria) this;
        }

        public Criteria andOrderMoneyIn(List<Double> values) {
            addCriterion("ORDER_MONEY in", values, "orderMoney");
            return (Criteria) this;
        }

        public Criteria andOrderMoneyNotIn(List<Double> values) {
            addCriterion("ORDER_MONEY not in", values, "orderMoney");
            return (Criteria) this;
        }

        public Criteria andOrderMoneyBetween(Double value1, Double value2) {
            addCriterion("ORDER_MONEY between", value1, value2, "orderMoney");
            return (Criteria) this;
        }

        public Criteria andOrderMoneyNotBetween(Double value1, Double value2) {
            addCriterion("ORDER_MONEY not between", value1, value2, "orderMoney");
            return (Criteria) this;
        }

        public Criteria andFJTimeIsNull() {
            addCriterion("F_J_TIME is null");
            return (Criteria) this;
        }

        public Criteria andFJTimeIsNotNull() {
            addCriterion("F_J_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andFJTimeEqualTo(Date value) {
            addCriterion("F_J_TIME =", value, "fJTime");
            return (Criteria) this;
        }

        public Criteria andFJTimeNotEqualTo(Date value) {
            addCriterion("F_J_TIME <>", value, "fJTime");
            return (Criteria) this;
        }

        public Criteria andFJTimeGreaterThan(Date value) {
            addCriterion("F_J_TIME >", value, "fJTime");
            return (Criteria) this;
        }

        public Criteria andFJTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("F_J_TIME >=", value, "fJTime");
            return (Criteria) this;
        }

        public Criteria andFJTimeLessThan(Date value) {
            addCriterion("F_J_TIME <", value, "fJTime");
            return (Criteria) this;
        }

        public Criteria andFJTimeLessThanOrEqualTo(Date value) {
            addCriterion("F_J_TIME <=", value, "fJTime");
            return (Criteria) this;
        }

        public Criteria andFJTimeIn(List<Date> values) {
            addCriterion("F_J_TIME in", values, "fJTime");
            return (Criteria) this;
        }

        public Criteria andFJTimeNotIn(List<Date> values) {
            addCriterion("F_J_TIME not in", values, "fJTime");
            return (Criteria) this;
        }

        public Criteria andFJTimeBetween(Date value1, Date value2) {
            addCriterion("F_J_TIME between", value1, value2, "fJTime");
            return (Criteria) this;
        }

        public Criteria andFJTimeNotBetween(Date value1, Date value2) {
            addCriterion("F_J_TIME not between", value1, value2, "fJTime");
            return (Criteria) this;
        }

        public Criteria andExpectTimeIsNull() {
            addCriterion("EXPECT_TIME is null");
            return (Criteria) this;
        }

        public Criteria andExpectTimeIsNotNull() {
            addCriterion("EXPECT_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andExpectTimeEqualTo(Date value) {
            addCriterion("EXPECT_TIME =", value, "expectTime");
            return (Criteria) this;
        }

        public Criteria andExpectTimeNotEqualTo(Date value) {
            addCriterion("EXPECT_TIME <>", value, "expectTime");
            return (Criteria) this;
        }

        public Criteria andExpectTimeGreaterThan(Date value) {
            addCriterion("EXPECT_TIME >", value, "expectTime");
            return (Criteria) this;
        }

        public Criteria andExpectTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("EXPECT_TIME >=", value, "expectTime");
            return (Criteria) this;
        }

        public Criteria andExpectTimeLessThan(Date value) {
            addCriterion("EXPECT_TIME <", value, "expectTime");
            return (Criteria) this;
        }

        public Criteria andExpectTimeLessThanOrEqualTo(Date value) {
            addCriterion("EXPECT_TIME <=", value, "expectTime");
            return (Criteria) this;
        }

        public Criteria andExpectTimeIn(List<Date> values) {
            addCriterion("EXPECT_TIME in", values, "expectTime");
            return (Criteria) this;
        }

        public Criteria andExpectTimeNotIn(List<Date> values) {
            addCriterion("EXPECT_TIME not in", values, "expectTime");
            return (Criteria) this;
        }

        public Criteria andExpectTimeBetween(Date value1, Date value2) {
            addCriterion("EXPECT_TIME between", value1, value2, "expectTime");
            return (Criteria) this;
        }

        public Criteria andExpectTimeNotBetween(Date value1, Date value2) {
            addCriterion("EXPECT_TIME not between", value1, value2, "expectTime");
            return (Criteria) this;
        }

        public Criteria andLStatusIsNull() {
            addCriterion("L_STATUS is null");
            return (Criteria) this;
        }

        public Criteria andLStatusIsNotNull() {
            addCriterion("L_STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andLStatusEqualTo(Integer value) {
            addCriterion("L_STATUS =", value, "lStatus");
            return (Criteria) this;
        }

        public Criteria andLStatusNotEqualTo(Integer value) {
            addCriterion("L_STATUS <>", value, "lStatus");
            return (Criteria) this;
        }

        public Criteria andLStatusGreaterThan(Integer value) {
            addCriterion("L_STATUS >", value, "lStatus");
            return (Criteria) this;
        }

        public Criteria andLStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("L_STATUS >=", value, "lStatus");
            return (Criteria) this;
        }

        public Criteria andLStatusLessThan(Integer value) {
            addCriterion("L_STATUS <", value, "lStatus");
            return (Criteria) this;
        }

        public Criteria andLStatusLessThanOrEqualTo(Integer value) {
            addCriterion("L_STATUS <=", value, "lStatus");
            return (Criteria) this;
        }

        public Criteria andLStatusIn(List<Integer> values) {
            addCriterion("L_STATUS in", values, "lStatus");
            return (Criteria) this;
        }

        public Criteria andLStatusNotIn(List<Integer> values) {
            addCriterion("L_STATUS not in", values, "lStatus");
            return (Criteria) this;
        }

        public Criteria andLStatusBetween(Integer value1, Integer value2) {
            addCriterion("L_STATUS between", value1, value2, "lStatus");
            return (Criteria) this;
        }

        public Criteria andLStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("L_STATUS not between", value1, value2, "lStatus");
            return (Criteria) this;
        }

        public Criteria andLCTimeIsNull() {
            addCriterion("L_C_TIME is null");
            return (Criteria) this;
        }

        public Criteria andLCTimeIsNotNull() {
            addCriterion("L_C_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andLCTimeEqualTo(Date value) {
            addCriterion("L_C_TIME =", value, "lCTime");
            return (Criteria) this;
        }

        public Criteria andLCTimeNotEqualTo(Date value) {
            addCriterion("L_C_TIME <>", value, "lCTime");
            return (Criteria) this;
        }

        public Criteria andLCTimeGreaterThan(Date value) {
            addCriterion("L_C_TIME >", value, "lCTime");
            return (Criteria) this;
        }

        public Criteria andLCTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("L_C_TIME >=", value, "lCTime");
            return (Criteria) this;
        }

        public Criteria andLCTimeLessThan(Date value) {
            addCriterion("L_C_TIME <", value, "lCTime");
            return (Criteria) this;
        }

        public Criteria andLCTimeLessThanOrEqualTo(Date value) {
            addCriterion("L_C_TIME <=", value, "lCTime");
            return (Criteria) this;
        }

        public Criteria andLCTimeIn(List<Date> values) {
            addCriterion("L_C_TIME in", values, "lCTime");
            return (Criteria) this;
        }

        public Criteria andLCTimeNotIn(List<Date> values) {
            addCriterion("L_C_TIME not in", values, "lCTime");
            return (Criteria) this;
        }

        public Criteria andLCTimeBetween(Date value1, Date value2) {
            addCriterion("L_C_TIME between", value1, value2, "lCTime");
            return (Criteria) this;
        }

        public Criteria andLCTimeNotBetween(Date value1, Date value2) {
            addCriterion("L_C_TIME not between", value1, value2, "lCTime");
            return (Criteria) this;
        }

        public Criteria andLAuthorIsNull() {
            addCriterion("L_AUTHOR is null");
            return (Criteria) this;
        }

        public Criteria andLAuthorIsNotNull() {
            addCriterion("L_AUTHOR is not null");
            return (Criteria) this;
        }

        public Criteria andLAuthorEqualTo(String value) {
            addCriterion("L_AUTHOR =", value, "lAuthor");
            return (Criteria) this;
        }

        public Criteria andLAuthorNotEqualTo(String value) {
            addCriterion("L_AUTHOR <>", value, "lAuthor");
            return (Criteria) this;
        }

        public Criteria andLAuthorGreaterThan(String value) {
            addCriterion("L_AUTHOR >", value, "lAuthor");
            return (Criteria) this;
        }

        public Criteria andLAuthorGreaterThanOrEqualTo(String value) {
            addCriterion("L_AUTHOR >=", value, "lAuthor");
            return (Criteria) this;
        }

        public Criteria andLAuthorLessThan(String value) {
            addCriterion("L_AUTHOR <", value, "lAuthor");
            return (Criteria) this;
        }

        public Criteria andLAuthorLessThanOrEqualTo(String value) {
            addCriterion("L_AUTHOR <=", value, "lAuthor");
            return (Criteria) this;
        }

        public Criteria andLAuthorLike(String value) {
            addCriterion("L_AUTHOR like", value, "lAuthor");
            return (Criteria) this;
        }

        public Criteria andLAuthorNotLike(String value) {
            addCriterion("L_AUTHOR not like", value, "lAuthor");
            return (Criteria) this;
        }

        public Criteria andLAuthorIn(List<String> values) {
            addCriterion("L_AUTHOR in", values, "lAuthor");
            return (Criteria) this;
        }

        public Criteria andLAuthorNotIn(List<String> values) {
            addCriterion("L_AUTHOR not in", values, "lAuthor");
            return (Criteria) this;
        }

        public Criteria andLAuthorBetween(String value1, String value2) {
            addCriterion("L_AUTHOR between", value1, value2, "lAuthor");
            return (Criteria) this;
        }

        public Criteria andLAuthorNotBetween(String value1, String value2) {
            addCriterion("L_AUTHOR not between", value1, value2, "lAuthor");
            return (Criteria) this;
        }

        public Criteria andCpersonIsNull() {
            addCriterion("CPERSON is null");
            return (Criteria) this;
        }

        public Criteria andCpersonIsNotNull() {
            addCriterion("CPERSON is not null");
            return (Criteria) this;
        }

        public Criteria andCpersonEqualTo(String value) {
            addCriterion("CPERSON =", value, "cperson");
            return (Criteria) this;
        }

        public Criteria andCpersonNotEqualTo(String value) {
            addCriterion("CPERSON <>", value, "cperson");
            return (Criteria) this;
        }

        public Criteria andCpersonGreaterThan(String value) {
            addCriterion("CPERSON >", value, "cperson");
            return (Criteria) this;
        }

        public Criteria andCpersonGreaterThanOrEqualTo(String value) {
            addCriterion("CPERSON >=", value, "cperson");
            return (Criteria) this;
        }

        public Criteria andCpersonLessThan(String value) {
            addCriterion("CPERSON <", value, "cperson");
            return (Criteria) this;
        }

        public Criteria andCpersonLessThanOrEqualTo(String value) {
            addCriterion("CPERSON <=", value, "cperson");
            return (Criteria) this;
        }

        public Criteria andCpersonLike(String value) {
            addCriterion("CPERSON like", value, "cperson");
            return (Criteria) this;
        }

        public Criteria andCpersonNotLike(String value) {
            addCriterion("CPERSON not like", value, "cperson");
            return (Criteria) this;
        }

        public Criteria andCpersonIn(List<String> values) {
            addCriterion("CPERSON in", values, "cperson");
            return (Criteria) this;
        }

        public Criteria andCpersonNotIn(List<String> values) {
            addCriterion("CPERSON not in", values, "cperson");
            return (Criteria) this;
        }

        public Criteria andCpersonBetween(String value1, String value2) {
            addCriterion("CPERSON between", value1, value2, "cperson");
            return (Criteria) this;
        }

        public Criteria andCpersonNotBetween(String value1, String value2) {
            addCriterion("CPERSON not between", value1, value2, "cperson");
            return (Criteria) this;
        }

        public Criteria andInvoiceDeliverMethodIsNull() {
            addCriterion("INVOICE_DELIVER_METHOD is null");
            return (Criteria) this;
        }

        public Criteria andInvoiceDeliverMethodIsNotNull() {
            addCriterion("INVOICE_DELIVER_METHOD is not null");
            return (Criteria) this;
        }

        public Criteria andInvoiceDeliverMethodEqualTo(Integer value) {
            addCriterion("INVOICE_DELIVER_METHOD =", value, "invoiceDeliverMethod");
            return (Criteria) this;
        }

        public Criteria andInvoiceDeliverMethodNotEqualTo(Integer value) {
            addCriterion("INVOICE_DELIVER_METHOD <>", value, "invoiceDeliverMethod");
            return (Criteria) this;
        }

        public Criteria andInvoiceDeliverMethodGreaterThan(Integer value) {
            addCriterion("INVOICE_DELIVER_METHOD >", value, "invoiceDeliverMethod");
            return (Criteria) this;
        }

        public Criteria andInvoiceDeliverMethodGreaterThanOrEqualTo(Integer value) {
            addCriterion("INVOICE_DELIVER_METHOD >=", value, "invoiceDeliverMethod");
            return (Criteria) this;
        }

        public Criteria andInvoiceDeliverMethodLessThan(Integer value) {
            addCriterion("INVOICE_DELIVER_METHOD <", value, "invoiceDeliverMethod");
            return (Criteria) this;
        }

        public Criteria andInvoiceDeliverMethodLessThanOrEqualTo(Integer value) {
            addCriterion("INVOICE_DELIVER_METHOD <=", value, "invoiceDeliverMethod");
            return (Criteria) this;
        }

        public Criteria andInvoiceDeliverMethodIn(List<Integer> values) {
            addCriterion("INVOICE_DELIVER_METHOD in", values, "invoiceDeliverMethod");
            return (Criteria) this;
        }

        public Criteria andInvoiceDeliverMethodNotIn(List<Integer> values) {
            addCriterion("INVOICE_DELIVER_METHOD not in", values, "invoiceDeliverMethod");
            return (Criteria) this;
        }

        public Criteria andInvoiceDeliverMethodBetween(Integer value1, Integer value2) {
            addCriterion("INVOICE_DELIVER_METHOD between", value1, value2, "invoiceDeliverMethod");
            return (Criteria) this;
        }

        public Criteria andInvoiceDeliverMethodNotBetween(Integer value1, Integer value2) {
            addCriterion("INVOICE_DELIVER_METHOD not between", value1, value2, "invoiceDeliverMethod");
            return (Criteria) this;
        }

        public Criteria andRecGoodsTypeIsNull() {
            addCriterion("REC_GOODS_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andRecGoodsTypeIsNotNull() {
            addCriterion("REC_GOODS_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andRecGoodsTypeEqualTo(Integer value) {
            addCriterion("REC_GOODS_TYPE =", value, "recGoodsType");
            return (Criteria) this;
        }

        public Criteria andRecGoodsTypeNotEqualTo(Integer value) {
            addCriterion("REC_GOODS_TYPE <>", value, "recGoodsType");
            return (Criteria) this;
        }

        public Criteria andRecGoodsTypeGreaterThan(Integer value) {
            addCriterion("REC_GOODS_TYPE >", value, "recGoodsType");
            return (Criteria) this;
        }

        public Criteria andRecGoodsTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("REC_GOODS_TYPE >=", value, "recGoodsType");
            return (Criteria) this;
        }

        public Criteria andRecGoodsTypeLessThan(Integer value) {
            addCriterion("REC_GOODS_TYPE <", value, "recGoodsType");
            return (Criteria) this;
        }

        public Criteria andRecGoodsTypeLessThanOrEqualTo(Integer value) {
            addCriterion("REC_GOODS_TYPE <=", value, "recGoodsType");
            return (Criteria) this;
        }

        public Criteria andRecGoodsTypeIn(List<Integer> values) {
            addCriterion("REC_GOODS_TYPE in", values, "recGoodsType");
            return (Criteria) this;
        }

        public Criteria andRecGoodsTypeNotIn(List<Integer> values) {
            addCriterion("REC_GOODS_TYPE not in", values, "recGoodsType");
            return (Criteria) this;
        }

        public Criteria andRecGoodsTypeBetween(Integer value1, Integer value2) {
            addCriterion("REC_GOODS_TYPE between", value1, value2, "recGoodsType");
            return (Criteria) this;
        }

        public Criteria andRecGoodsTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("REC_GOODS_TYPE not between", value1, value2, "recGoodsType");
            return (Criteria) this;
        }

        public Criteria andRecGoodsCommnetIsNull() {
            addCriterion("REC_GOODS_COMMNET is null");
            return (Criteria) this;
        }

        public Criteria andRecGoodsCommnetIsNotNull() {
            addCriterion("REC_GOODS_COMMNET is not null");
            return (Criteria) this;
        }

        public Criteria andRecGoodsCommnetEqualTo(String value) {
            addCriterion("REC_GOODS_COMMNET =", value, "recGoodsCommnet");
            return (Criteria) this;
        }

        public Criteria andRecGoodsCommnetNotEqualTo(String value) {
            addCriterion("REC_GOODS_COMMNET <>", value, "recGoodsCommnet");
            return (Criteria) this;
        }

        public Criteria andRecGoodsCommnetGreaterThan(String value) {
            addCriterion("REC_GOODS_COMMNET >", value, "recGoodsCommnet");
            return (Criteria) this;
        }

        public Criteria andRecGoodsCommnetGreaterThanOrEqualTo(String value) {
            addCriterion("REC_GOODS_COMMNET >=", value, "recGoodsCommnet");
            return (Criteria) this;
        }

        public Criteria andRecGoodsCommnetLessThan(String value) {
            addCriterion("REC_GOODS_COMMNET <", value, "recGoodsCommnet");
            return (Criteria) this;
        }

        public Criteria andRecGoodsCommnetLessThanOrEqualTo(String value) {
            addCriterion("REC_GOODS_COMMNET <=", value, "recGoodsCommnet");
            return (Criteria) this;
        }

        public Criteria andRecGoodsCommnetLike(String value) {
            addCriterion("REC_GOODS_COMMNET like", value, "recGoodsCommnet");
            return (Criteria) this;
        }

        public Criteria andRecGoodsCommnetNotLike(String value) {
            addCriterion("REC_GOODS_COMMNET not like", value, "recGoodsCommnet");
            return (Criteria) this;
        }

        public Criteria andRecGoodsCommnetIn(List<String> values) {
            addCriterion("REC_GOODS_COMMNET in", values, "recGoodsCommnet");
            return (Criteria) this;
        }

        public Criteria andRecGoodsCommnetNotIn(List<String> values) {
            addCriterion("REC_GOODS_COMMNET not in", values, "recGoodsCommnet");
            return (Criteria) this;
        }

        public Criteria andRecGoodsCommnetBetween(String value1, String value2) {
            addCriterion("REC_GOODS_COMMNET between", value1, value2, "recGoodsCommnet");
            return (Criteria) this;
        }

        public Criteria andRecGoodsCommnetNotBetween(String value1, String value2) {
            addCriterion("REC_GOODS_COMMNET not between", value1, value2, "recGoodsCommnet");
            return (Criteria) this;
        }

        public Criteria andCommitTypeIsNull() {
            addCriterion("COMMIT_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andCommitTypeIsNotNull() {
            addCriterion("COMMIT_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andCommitTypeEqualTo(Integer value) {
            addCriterion("COMMIT_TYPE =", value, "commitType");
            return (Criteria) this;
        }

        public Criteria andCommitTypeNotEqualTo(Integer value) {
            addCriterion("COMMIT_TYPE <>", value, "commitType");
            return (Criteria) this;
        }

        public Criteria andCommitTypeGreaterThan(Integer value) {
            addCriterion("COMMIT_TYPE >", value, "commitType");
            return (Criteria) this;
        }

        public Criteria andCommitTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("COMMIT_TYPE >=", value, "commitType");
            return (Criteria) this;
        }

        public Criteria andCommitTypeLessThan(Integer value) {
            addCriterion("COMMIT_TYPE <", value, "commitType");
            return (Criteria) this;
        }

        public Criteria andCommitTypeLessThanOrEqualTo(Integer value) {
            addCriterion("COMMIT_TYPE <=", value, "commitType");
            return (Criteria) this;
        }

        public Criteria andCommitTypeIn(List<Integer> values) {
            addCriterion("COMMIT_TYPE in", values, "commitType");
            return (Criteria) this;
        }

        public Criteria andCommitTypeNotIn(List<Integer> values) {
            addCriterion("COMMIT_TYPE not in", values, "commitType");
            return (Criteria) this;
        }

        public Criteria andCommitTypeBetween(Integer value1, Integer value2) {
            addCriterion("COMMIT_TYPE between", value1, value2, "commitType");
            return (Criteria) this;
        }

        public Criteria andCommitTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("COMMIT_TYPE not between", value1, value2, "commitType");
            return (Criteria) this;
        }

        public Criteria andReplyStatusIsNull() {
            addCriterion("REPLY_STATUS is null");
            return (Criteria) this;
        }

        public Criteria andReplyStatusIsNotNull() {
            addCriterion("REPLY_STATUS is not null");
            return (Criteria) this;
        }

        public Criteria andReplyStatusEqualTo(Integer value) {
            addCriterion("REPLY_STATUS =", value, "replyStatus");
            return (Criteria) this;
        }

        public Criteria andReplyStatusNotEqualTo(Integer value) {
            addCriterion("REPLY_STATUS <>", value, "replyStatus");
            return (Criteria) this;
        }

        public Criteria andReplyStatusGreaterThan(Integer value) {
            addCriterion("REPLY_STATUS >", value, "replyStatus");
            return (Criteria) this;
        }

        public Criteria andReplyStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("REPLY_STATUS >=", value, "replyStatus");
            return (Criteria) this;
        }

        public Criteria andReplyStatusLessThan(Integer value) {
            addCriterion("REPLY_STATUS <", value, "replyStatus");
            return (Criteria) this;
        }

        public Criteria andReplyStatusLessThanOrEqualTo(Integer value) {
            addCriterion("REPLY_STATUS <=", value, "replyStatus");
            return (Criteria) this;
        }

        public Criteria andReplyStatusIn(List<Integer> values) {
            addCriterion("REPLY_STATUS in", values, "replyStatus");
            return (Criteria) this;
        }

        public Criteria andReplyStatusNotIn(List<Integer> values) {
            addCriterion("REPLY_STATUS not in", values, "replyStatus");
            return (Criteria) this;
        }

        public Criteria andReplyStatusBetween(Integer value1, Integer value2) {
            addCriterion("REPLY_STATUS between", value1, value2, "replyStatus");
            return (Criteria) this;
        }

        public Criteria andReplyStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("REPLY_STATUS not between", value1, value2, "replyStatus");
            return (Criteria) this;
        }

        public Criteria andSTypeIsNull() {
            addCriterion("S_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andSTypeIsNotNull() {
            addCriterion("S_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andSTypeEqualTo(Integer value) {
            addCriterion("S_TYPE =", value, "sType");
            return (Criteria) this;
        }

        public Criteria andSTypeNotEqualTo(Integer value) {
            addCriterion("S_TYPE <>", value, "sType");
            return (Criteria) this;
        }

        public Criteria andSTypeGreaterThan(Integer value) {
            addCriterion("S_TYPE >", value, "sType");
            return (Criteria) this;
        }

        public Criteria andSTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("S_TYPE >=", value, "sType");
            return (Criteria) this;
        }

        public Criteria andSTypeLessThan(Integer value) {
            addCriterion("S_TYPE <", value, "sType");
            return (Criteria) this;
        }

        public Criteria andSTypeLessThanOrEqualTo(Integer value) {
            addCriterion("S_TYPE <=", value, "sType");
            return (Criteria) this;
        }

        public Criteria andSTypeIn(List<Integer> values) {
            addCriterion("S_TYPE in", values, "sType");
            return (Criteria) this;
        }

        public Criteria andSTypeNotIn(List<Integer> values) {
            addCriterion("S_TYPE not in", values, "sType");
            return (Criteria) this;
        }

        public Criteria andSTypeBetween(Integer value1, Integer value2) {
            addCriterion("S_TYPE between", value1, value2, "sType");
            return (Criteria) this;
        }

        public Criteria andSTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("S_TYPE not between", value1, value2, "sType");
            return (Criteria) this;
        }

        public Criteria andLPhoneIsNull() {
            addCriterion("L_PHONE is null");
            return (Criteria) this;
        }

        public Criteria andLPhoneIsNotNull() {
            addCriterion("L_PHONE is not null");
            return (Criteria) this;
        }

        public Criteria andLPhoneEqualTo(String value) {
            addCriterion("L_PHONE =", value, "lPhone");
            return (Criteria) this;
        }

        public Criteria andLPhoneNotEqualTo(String value) {
            addCriterion("L_PHONE <>", value, "lPhone");
            return (Criteria) this;
        }

        public Criteria andLPhoneGreaterThan(String value) {
            addCriterion("L_PHONE >", value, "lPhone");
            return (Criteria) this;
        }

        public Criteria andLPhoneGreaterThanOrEqualTo(String value) {
            addCriterion("L_PHONE >=", value, "lPhone");
            return (Criteria) this;
        }

        public Criteria andLPhoneLessThan(String value) {
            addCriterion("L_PHONE <", value, "lPhone");
            return (Criteria) this;
        }

        public Criteria andLPhoneLessThanOrEqualTo(String value) {
            addCriterion("L_PHONE <=", value, "lPhone");
            return (Criteria) this;
        }

        public Criteria andLPhoneLike(String value) {
            addCriterion("L_PHONE like", value, "lPhone");
            return (Criteria) this;
        }

        public Criteria andLPhoneNotLike(String value) {
            addCriterion("L_PHONE not like", value, "lPhone");
            return (Criteria) this;
        }

        public Criteria andLPhoneIn(List<String> values) {
            addCriterion("L_PHONE in", values, "lPhone");
            return (Criteria) this;
        }

        public Criteria andLPhoneNotIn(List<String> values) {
            addCriterion("L_PHONE not in", values, "lPhone");
            return (Criteria) this;
        }

        public Criteria andLPhoneBetween(String value1, String value2) {
            addCriterion("L_PHONE between", value1, value2, "lPhone");
            return (Criteria) this;
        }

        public Criteria andLPhoneNotBetween(String value1, String value2) {
            addCriterion("L_PHONE not between", value1, value2, "lPhone");
            return (Criteria) this;
        }

        public Criteria andSidIsNull() {
            addCriterion("SID is null");
            return (Criteria) this;
        }

        public Criteria andSidIsNotNull() {
            addCriterion("SID is not null");
            return (Criteria) this;
        }

        public Criteria andSidEqualTo(Integer value) {
            addCriterion("SID =", value, "sid");
            return (Criteria) this;
        }

        public Criteria andSidNotEqualTo(Integer value) {
            addCriterion("SID <>", value, "sid");
            return (Criteria) this;
        }

        public Criteria andSidGreaterThan(Integer value) {
            addCriterion("SID >", value, "sid");
            return (Criteria) this;
        }

        public Criteria andSidGreaterThanOrEqualTo(Integer value) {
            addCriterion("SID >=", value, "sid");
            return (Criteria) this;
        }

        public Criteria andSidLessThan(Integer value) {
            addCriterion("SID <", value, "sid");
            return (Criteria) this;
        }

        public Criteria andSidLessThanOrEqualTo(Integer value) {
            addCriterion("SID <=", value, "sid");
            return (Criteria) this;
        }

        public Criteria andSidIn(List<Integer> values) {
            addCriterion("SID in", values, "sid");
            return (Criteria) this;
        }

        public Criteria andSidNotIn(List<Integer> values) {
            addCriterion("SID not in", values, "sid");
            return (Criteria) this;
        }

        public Criteria andSidBetween(Integer value1, Integer value2) {
            addCriterion("SID between", value1, value2, "sid");
            return (Criteria) this;
        }

        public Criteria andSidNotBetween(Integer value1, Integer value2) {
            addCriterion("SID not between", value1, value2, "sid");
            return (Criteria) this;
        }

        public Criteria andOAuthorIsNull() {
            addCriterion("O_AUTHOR is null");
            return (Criteria) this;
        }

        public Criteria andOAuthorIsNotNull() {
            addCriterion("O_AUTHOR is not null");
            return (Criteria) this;
        }

        public Criteria andOAuthorEqualTo(String value) {
            addCriterion("O_AUTHOR =", value, "oAuthor");
            return (Criteria) this;
        }

        public Criteria andOAuthorNotEqualTo(String value) {
            addCriterion("O_AUTHOR <>", value, "oAuthor");
            return (Criteria) this;
        }

        public Criteria andOAuthorGreaterThan(String value) {
            addCriterion("O_AUTHOR >", value, "oAuthor");
            return (Criteria) this;
        }

        public Criteria andOAuthorGreaterThanOrEqualTo(String value) {
            addCriterion("O_AUTHOR >=", value, "oAuthor");
            return (Criteria) this;
        }

        public Criteria andOAuthorLessThan(String value) {
            addCriterion("O_AUTHOR <", value, "oAuthor");
            return (Criteria) this;
        }

        public Criteria andOAuthorLessThanOrEqualTo(String value) {
            addCriterion("O_AUTHOR <=", value, "oAuthor");
            return (Criteria) this;
        }

        public Criteria andOAuthorLike(String value) {
            addCriterion("O_AUTHOR like", value, "oAuthor");
            return (Criteria) this;
        }

        public Criteria andOAuthorNotLike(String value) {
            addCriterion("O_AUTHOR not like", value, "oAuthor");
            return (Criteria) this;
        }

        public Criteria andOAuthorIn(List<String> values) {
            addCriterion("O_AUTHOR in", values, "oAuthor");
            return (Criteria) this;
        }

        public Criteria andOAuthorNotIn(List<String> values) {
            addCriterion("O_AUTHOR not in", values, "oAuthor");
            return (Criteria) this;
        }

        public Criteria andOAuthorBetween(String value1, String value2) {
            addCriterion("O_AUTHOR between", value1, value2, "oAuthor");
            return (Criteria) this;
        }

        public Criteria andOAuthorNotBetween(String value1, String value2) {
            addCriterion("O_AUTHOR not between", value1, value2, "oAuthor");
            return (Criteria) this;
        }

        public Criteria andRDateIsNull() {
            addCriterion("R_DATE is null");
            return (Criteria) this;
        }

        public Criteria andRDateIsNotNull() {
            addCriterion("R_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andRDateEqualTo(Date value) {
            addCriterion("R_DATE =", value, "rDate");
            return (Criteria) this;
        }

        public Criteria andRDateNotEqualTo(Date value) {
            addCriterion("R_DATE <>", value, "rDate");
            return (Criteria) this;
        }

        public Criteria andRDateGreaterThan(Date value) {
            addCriterion("R_DATE >", value, "rDate");
            return (Criteria) this;
        }

        public Criteria andRDateGreaterThanOrEqualTo(Date value) {
            addCriterion("R_DATE >=", value, "rDate");
            return (Criteria) this;
        }

        public Criteria andRDateLessThan(Date value) {
            addCriterion("R_DATE <", value, "rDate");
            return (Criteria) this;
        }

        public Criteria andRDateLessThanOrEqualTo(Date value) {
            addCriterion("R_DATE <=", value, "rDate");
            return (Criteria) this;
        }

        public Criteria andRDateIn(List<Date> values) {
            addCriterion("R_DATE in", values, "rDate");
            return (Criteria) this;
        }

        public Criteria andRDateNotIn(List<Date> values) {
            addCriterion("R_DATE not in", values, "rDate");
            return (Criteria) this;
        }

        public Criteria andRDateBetween(Date value1, Date value2) {
            addCriterion("R_DATE between", value1, value2, "rDate");
            return (Criteria) this;
        }

        public Criteria andRDateNotBetween(Date value1, Date value2) {
            addCriterion("R_DATE not between", value1, value2, "rDate");
            return (Criteria) this;
        }

        public Criteria andRpersonIsNull() {
            addCriterion("RPERSON is null");
            return (Criteria) this;
        }

        public Criteria andRpersonIsNotNull() {
            addCriterion("RPERSON is not null");
            return (Criteria) this;
        }

        public Criteria andRpersonEqualTo(String value) {
            addCriterion("RPERSON =", value, "rperson");
            return (Criteria) this;
        }

        public Criteria andRpersonNotEqualTo(String value) {
            addCriterion("RPERSON <>", value, "rperson");
            return (Criteria) this;
        }

        public Criteria andRpersonGreaterThan(String value) {
            addCriterion("RPERSON >", value, "rperson");
            return (Criteria) this;
        }

        public Criteria andRpersonGreaterThanOrEqualTo(String value) {
            addCriterion("RPERSON >=", value, "rperson");
            return (Criteria) this;
        }

        public Criteria andRpersonLessThan(String value) {
            addCriterion("RPERSON <", value, "rperson");
            return (Criteria) this;
        }

        public Criteria andRpersonLessThanOrEqualTo(String value) {
            addCriterion("RPERSON <=", value, "rperson");
            return (Criteria) this;
        }

        public Criteria andRpersonLike(String value) {
            addCriterion("RPERSON like", value, "rperson");
            return (Criteria) this;
        }

        public Criteria andRpersonNotLike(String value) {
            addCriterion("RPERSON not like", value, "rperson");
            return (Criteria) this;
        }

        public Criteria andRpersonIn(List<String> values) {
            addCriterion("RPERSON in", values, "rperson");
            return (Criteria) this;
        }

        public Criteria andRpersonNotIn(List<String> values) {
            addCriterion("RPERSON not in", values, "rperson");
            return (Criteria) this;
        }

        public Criteria andRpersonBetween(String value1, String value2) {
            addCriterion("RPERSON between", value1, value2, "rperson");
            return (Criteria) this;
        }

        public Criteria andRpersonNotBetween(String value1, String value2) {
            addCriterion("RPERSON not between", value1, value2, "rperson");
            return (Criteria) this;
        }

        public Criteria andPredictTimeIsNull() {
            addCriterion("PREDICT_TIME is null");
            return (Criteria) this;
        }

        public Criteria andPredictTimeIsNotNull() {
            addCriterion("PREDICT_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andPredictTimeEqualTo(Date value) {
            addCriterion("PREDICT_TIME =", value, "predictTime");
            return (Criteria) this;
        }

        public Criteria andPredictTimeNotEqualTo(Date value) {
            addCriterion("PREDICT_TIME <>", value, "predictTime");
            return (Criteria) this;
        }

        public Criteria andPredictTimeGreaterThan(Date value) {
            addCriterion("PREDICT_TIME >", value, "predictTime");
            return (Criteria) this;
        }

        public Criteria andPredictTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("PREDICT_TIME >=", value, "predictTime");
            return (Criteria) this;
        }

        public Criteria andPredictTimeLessThan(Date value) {
            addCriterion("PREDICT_TIME <", value, "predictTime");
            return (Criteria) this;
        }

        public Criteria andPredictTimeLessThanOrEqualTo(Date value) {
            addCriterion("PREDICT_TIME <=", value, "predictTime");
            return (Criteria) this;
        }

        public Criteria andPredictTimeIn(List<Date> values) {
            addCriterion("PREDICT_TIME in", values, "predictTime");
            return (Criteria) this;
        }

        public Criteria andPredictTimeNotIn(List<Date> values) {
            addCriterion("PREDICT_TIME not in", values, "predictTime");
            return (Criteria) this;
        }

        public Criteria andPredictTimeBetween(Date value1, Date value2) {
            addCriterion("PREDICT_TIME between", value1, value2, "predictTime");
            return (Criteria) this;
        }

        public Criteria andPredictTimeNotBetween(Date value1, Date value2) {
            addCriterion("PREDICT_TIME not between", value1, value2, "predictTime");
            return (Criteria) this;
        }

        public Criteria andModifTimeIsNull() {
            addCriterion("MODIF_TIME is null");
            return (Criteria) this;
        }

        public Criteria andModifTimeIsNotNull() {
            addCriterion("MODIF_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andModifTimeEqualTo(Date value) {
            addCriterion("MODIF_TIME =", value, "modifTime");
            return (Criteria) this;
        }

        public Criteria andModifTimeNotEqualTo(Date value) {
            addCriterion("MODIF_TIME <>", value, "modifTime");
            return (Criteria) this;
        }

        public Criteria andModifTimeGreaterThan(Date value) {
            addCriterion("MODIF_TIME >", value, "modifTime");
            return (Criteria) this;
        }

        public Criteria andModifTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("MODIF_TIME >=", value, "modifTime");
            return (Criteria) this;
        }

        public Criteria andModifTimeLessThan(Date value) {
            addCriterion("MODIF_TIME <", value, "modifTime");
            return (Criteria) this;
        }

        public Criteria andModifTimeLessThanOrEqualTo(Date value) {
            addCriterion("MODIF_TIME <=", value, "modifTime");
            return (Criteria) this;
        }

        public Criteria andModifTimeIn(List<Date> values) {
            addCriterion("MODIF_TIME in", values, "modifTime");
            return (Criteria) this;
        }

        public Criteria andModifTimeNotIn(List<Date> values) {
            addCriterion("MODIF_TIME not in", values, "modifTime");
            return (Criteria) this;
        }

        public Criteria andModifTimeBetween(Date value1, Date value2) {
            addCriterion("MODIF_TIME between", value1, value2, "modifTime");
            return (Criteria) this;
        }

        public Criteria andModifTimeNotBetween(Date value1, Date value2) {
            addCriterion("MODIF_TIME not between", value1, value2, "modifTime");
            return (Criteria) this;
        }

        public Criteria andAddrIsNull() {
            addCriterion("ADDR is null");
            return (Criteria) this;
        }

        public Criteria andAddrIsNotNull() {
            addCriterion("ADDR is not null");
            return (Criteria) this;
        }

        public Criteria andAddrEqualTo(String value) {
            addCriterion("ADDR =", value, "addr");
            return (Criteria) this;
        }

        public Criteria andAddrNotEqualTo(String value) {
            addCriterion("ADDR <>", value, "addr");
            return (Criteria) this;
        }

        public Criteria andAddrGreaterThan(String value) {
            addCriterion("ADDR >", value, "addr");
            return (Criteria) this;
        }

        public Criteria andAddrGreaterThanOrEqualTo(String value) {
            addCriterion("ADDR >=", value, "addr");
            return (Criteria) this;
        }

        public Criteria andAddrLessThan(String value) {
            addCriterion("ADDR <", value, "addr");
            return (Criteria) this;
        }

        public Criteria andAddrLessThanOrEqualTo(String value) {
            addCriterion("ADDR <=", value, "addr");
            return (Criteria) this;
        }

        public Criteria andAddrLike(String value) {
            addCriterion("ADDR like", value, "addr");
            return (Criteria) this;
        }

        public Criteria andAddrNotLike(String value) {
            addCriterion("ADDR not like", value, "addr");
            return (Criteria) this;
        }

        public Criteria andAddrIn(List<String> values) {
            addCriterion("ADDR in", values, "addr");
            return (Criteria) this;
        }

        public Criteria andAddrNotIn(List<String> values) {
            addCriterion("ADDR not in", values, "addr");
            return (Criteria) this;
        }

        public Criteria andAddrBetween(String value1, String value2) {
            addCriterion("ADDR between", value1, value2, "addr");
            return (Criteria) this;
        }

        public Criteria andAddrNotBetween(String value1, String value2) {
            addCriterion("ADDR not between", value1, value2, "addr");
            return (Criteria) this;
        }

        public Criteria andIsRecCompleteIsNull() {
            addCriterion("IS_REC_COMPLETE is null");
            return (Criteria) this;
        }

        public Criteria andIsRecCompleteIsNotNull() {
            addCriterion("IS_REC_COMPLETE is not null");
            return (Criteria) this;
        }

        public Criteria andIsRecCompleteEqualTo(Integer value) {
            addCriterion("IS_REC_COMPLETE =", value, "isRecComplete");
            return (Criteria) this;
        }

        public Criteria andIsRecCompleteNotEqualTo(Integer value) {
            addCriterion("IS_REC_COMPLETE <>", value, "isRecComplete");
            return (Criteria) this;
        }

        public Criteria andIsRecCompleteGreaterThan(Integer value) {
            addCriterion("IS_REC_COMPLETE >", value, "isRecComplete");
            return (Criteria) this;
        }

        public Criteria andIsRecCompleteGreaterThanOrEqualTo(Integer value) {
            addCriterion("IS_REC_COMPLETE >=", value, "isRecComplete");
            return (Criteria) this;
        }

        public Criteria andIsRecCompleteLessThan(Integer value) {
            addCriterion("IS_REC_COMPLETE <", value, "isRecComplete");
            return (Criteria) this;
        }

        public Criteria andIsRecCompleteLessThanOrEqualTo(Integer value) {
            addCriterion("IS_REC_COMPLETE <=", value, "isRecComplete");
            return (Criteria) this;
        }

        public Criteria andIsRecCompleteIn(List<Integer> values) {
            addCriterion("IS_REC_COMPLETE in", values, "isRecComplete");
            return (Criteria) this;
        }

        public Criteria andIsRecCompleteNotIn(List<Integer> values) {
            addCriterion("IS_REC_COMPLETE not in", values, "isRecComplete");
            return (Criteria) this;
        }

        public Criteria andIsRecCompleteBetween(Integer value1, Integer value2) {
            addCriterion("IS_REC_COMPLETE between", value1, value2, "isRecComplete");
            return (Criteria) this;
        }

        public Criteria andIsRecCompleteNotBetween(Integer value1, Integer value2) {
            addCriterion("IS_REC_COMPLETE not between", value1, value2, "isRecComplete");
            return (Criteria) this;
        }

        public Criteria andCycleIsNull() {
            addCriterion("CYCLE is null");
            return (Criteria) this;
        }

        public Criteria andCycleIsNotNull() {
            addCriterion("CYCLE is not null");
            return (Criteria) this;
        }

        public Criteria andCycleEqualTo(Integer value) {
            addCriterion("CYCLE =", value, "cycle");
            return (Criteria) this;
        }

        public Criteria andCycleNotEqualTo(Integer value) {
            addCriterion("CYCLE <>", value, "cycle");
            return (Criteria) this;
        }

        public Criteria andCycleGreaterThan(Integer value) {
            addCriterion("CYCLE >", value, "cycle");
            return (Criteria) this;
        }

        public Criteria andCycleGreaterThanOrEqualTo(Integer value) {
            addCriterion("CYCLE >=", value, "cycle");
            return (Criteria) this;
        }

        public Criteria andCycleLessThan(Integer value) {
            addCriterion("CYCLE <", value, "cycle");
            return (Criteria) this;
        }

        public Criteria andCycleLessThanOrEqualTo(Integer value) {
            addCriterion("CYCLE <=", value, "cycle");
            return (Criteria) this;
        }

        public Criteria andCycleIn(List<Integer> values) {
            addCriterion("CYCLE in", values, "cycle");
            return (Criteria) this;
        }

        public Criteria andCycleNotIn(List<Integer> values) {
            addCriterion("CYCLE not in", values, "cycle");
            return (Criteria) this;
        }

        public Criteria andCycleBetween(Integer value1, Integer value2) {
            addCriterion("CYCLE between", value1, value2, "cycle");
            return (Criteria) this;
        }

        public Criteria andCycleNotBetween(Integer value1, Integer value2) {
            addCriterion("CYCLE not between", value1, value2, "cycle");
            return (Criteria) this;
        }

        public Criteria andEarlyDayIsNull() {
            addCriterion("EARLY_DAY is null");
            return (Criteria) this;
        }

        public Criteria andEarlyDayIsNotNull() {
            addCriterion("EARLY_DAY is not null");
            return (Criteria) this;
        }

        public Criteria andEarlyDayEqualTo(Integer value) {
            addCriterion("EARLY_DAY =", value, "earlyDay");
            return (Criteria) this;
        }

        public Criteria andEarlyDayNotEqualTo(Integer value) {
            addCriterion("EARLY_DAY <>", value, "earlyDay");
            return (Criteria) this;
        }

        public Criteria andEarlyDayGreaterThan(Integer value) {
            addCriterion("EARLY_DAY >", value, "earlyDay");
            return (Criteria) this;
        }

        public Criteria andEarlyDayGreaterThanOrEqualTo(Integer value) {
            addCriterion("EARLY_DAY >=", value, "earlyDay");
            return (Criteria) this;
        }

        public Criteria andEarlyDayLessThan(Integer value) {
            addCriterion("EARLY_DAY <", value, "earlyDay");
            return (Criteria) this;
        }

        public Criteria andEarlyDayLessThanOrEqualTo(Integer value) {
            addCriterion("EARLY_DAY <=", value, "earlyDay");
            return (Criteria) this;
        }

        public Criteria andEarlyDayIn(List<Integer> values) {
            addCriterion("EARLY_DAY in", values, "earlyDay");
            return (Criteria) this;
        }

        public Criteria andEarlyDayNotIn(List<Integer> values) {
            addCriterion("EARLY_DAY not in", values, "earlyDay");
            return (Criteria) this;
        }

        public Criteria andEarlyDayBetween(Integer value1, Integer value2) {
            addCriterion("EARLY_DAY between", value1, value2, "earlyDay");
            return (Criteria) this;
        }

        public Criteria andEarlyDayNotBetween(Integer value1, Integer value2) {
            addCriterion("EARLY_DAY not between", value1, value2, "earlyDay");
            return (Criteria) this;
        }

        public Criteria andCnameIsNull() {
            addCriterion("CNAME is null");
            return (Criteria) this;
        }

        public Criteria andCnameIsNotNull() {
            addCriterion("CNAME is not null");
            return (Criteria) this;
        }

        public Criteria andCnameEqualTo(String value) {
            addCriterion("CNAME =", value, "cname");
            return (Criteria) this;
        }

        public Criteria andCnameNotEqualTo(String value) {
            addCriterion("CNAME <>", value, "cname");
            return (Criteria) this;
        }

        public Criteria andCnameGreaterThan(String value) {
            addCriterion("CNAME >", value, "cname");
            return (Criteria) this;
        }

        public Criteria andCnameGreaterThanOrEqualTo(String value) {
            addCriterion("CNAME >=", value, "cname");
            return (Criteria) this;
        }

        public Criteria andCnameLessThan(String value) {
            addCriterion("CNAME <", value, "cname");
            return (Criteria) this;
        }

        public Criteria andCnameLessThanOrEqualTo(String value) {
            addCriterion("CNAME <=", value, "cname");
            return (Criteria) this;
        }

        public Criteria andCnameLike(String value) {
            addCriterion("CNAME like", value, "cname");
            return (Criteria) this;
        }

        public Criteria andCnameNotLike(String value) {
            addCriterion("CNAME not like", value, "cname");
            return (Criteria) this;
        }

        public Criteria andCnameIn(List<String> values) {
            addCriterion("CNAME in", values, "cname");
            return (Criteria) this;
        }

        public Criteria andCnameNotIn(List<String> values) {
            addCriterion("CNAME not in", values, "cname");
            return (Criteria) this;
        }

        public Criteria andCnameBetween(String value1, String value2) {
            addCriterion("CNAME between", value1, value2, "cname");
            return (Criteria) this;
        }

        public Criteria andCnameNotBetween(String value1, String value2) {
            addCriterion("CNAME not between", value1, value2, "cname");
            return (Criteria) this;
        }
    }

    /**
     * This class was generated by MyBatis Generator.
     * This class corresponds to the database table ORDER_REC
     *
     * @mbg.generated do_not_delete_during_merge Wed Jul 12 08:41:20 CST 2017
     */
    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}